![]() |
Java Database Programming with JDBC
by Pratik Patel Coriolis, The Coriolis Group ISBN: 1576100561 Pub Date: 10/01/96 |
Previous | Table of Contents | Next |
Methods
Method Name | Additional Description |
---|---|
public abstract boolean allProceduresAreCallable() throwsk SQLException | Returns true if all the procedures available to the user are callable |
public abstract boolean allTablesAreSelectable() throws SQLException | Returns true if all of the tables are accessible to the user on the open connection |
public abstract boolean dataDefinitionCausesTransactionCommit() throws SQLException | Returns true if data defintion causes the transaction to commit |
public abstract boolean dataDefinitionIgnoredInTransactions() throws SQLException | Returns true if data defintion is ignored in the transaction |
public abstract boolean doesMaxRowSizeIncludeBlobs() throws SQLException | Returns true if the getMaxSize method does not account for the size of LONGVARCHAR and LONGVARBINARY SQL data types |
public abstract ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullok) throws SQLException | Returns a ResultSet object for the specified parameters that gets the specified tables key or the attributes that can be used to uniquely identify a row, which may be composite; the scope parameter is one of the constants: bestRowTemporary, bestRowTransaction, or betRowSession; the nullok parameter allows columns that may be null; the ResultSet is composed of the following columns: scope (of the same types as above scope parameter), column name, SQL data type, name of the data type dependent on the database, precision, buffer length, significant places if a Numeric type, and pseudo column (one of the constants bestRowUnknown, bestRowNotPseudo, or bestRowPseudo) |
public abstract ResultSet getCatalogs() throws SQLException | Returns a ResultSet object that contains a column for the catalog names that are in the database |
public abstract String getCatalogSeparator() throws SQLException | Returns the separator between the catalog String and the table name |
public abstract String getCatalogTerm() throws SQLException | Returns the database-specific term for catalog |
public abstract ResultSet getColumnPrivileges(String catalog, String schemaString table, String columnNamePattern) throws SQLException | Returns a ResultSet object that contains information about the specified tables matching columnNamePattern; the returned ResultSet object contains the following columns: the catalog name that the table is in, the schema the table is in, the table name, the column name, owner of the table, grantee, type of access (SELECT, UPDATE, etc.), and if the grantee can grant access to others, YES, NO, or null (if unknown) |
public abstract ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException | Returns a ResultSet object that contains information about the matching columns for the matching tables and schemas; the ResultSet contains the following columns: catalog name, schema name, table name, column name, SQL data type, name of the type specific to the database, the maximum number of characters or precision depending on the data type, buffer length (not used), the number of digits (if applicable), radix (if applicable), null-ability (one of the constants columnNoNulls, columnNullable, columnNullableUnknown), comments for the column, default value (if it exists, else null), empty column, empty column, maximum number of bytes in the column of type CHAR (if applicable), index number of column; the last column is set to YES if it can contain NULLS if not NO else its empty if the status is unknown |
public abstract ResultSet get CrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException | Returns a ResultSet object that describes the way a table imports foreign keys; the ResultSet object returned by this method contains these columns: primary keys table catalog, primary keys table schema, primary keys table, primary keys column name, foreign keys table catalog, foreign keys table schema, foreign keys table, foreign keys column name, sequence number within foreign key, action to foreign key when primary key is updated (one of the constants importedKeyCascade, importedKeyRestrict, importedKeySetNull), action to foreign key when primary key is deleted (one of the constants importedKeyCascade, importedKeyRestrict, importedKeySetNull), foreign key identifier, and primary key indentifier |
public abstract String getDatabaseProductName() throws SQLException | Returns the database product name |
public abstract String getDatabaseProductVersion() throws SQLException | Returns the database product number |
public abstract int getDefaultTransactionIsolation() throws SQLException | Returns the default transaction isolation level as defined by the applicable constants in the Connection class |
public abstract int getDriverMajorVersion() | Gets the drivers major version |
public abstract int getDriverMinorVersion() | Gets the drivers minor version |
public abstract String getDriverName() throws SQLException | Returns the name of the JDBC driver |
public abstract String getDriverVersion() throws SQLException | Returns the version of the JDBC driver |
public abstract ResultSet getExportedKeys(String catalog, String schema, String table) throws SQLException | Returns a ResultSet object that describes the foreign key attributes that reference the specified tables primary key; the ResultSet object returns the following columns: primary keys table catalog, primary keys table schema, primary keys table, primary keys column name, foreign keys table catalog, foreign keys table schema, foreign keys table, foreign keys column name, sequence number within foreign key, action to foreign key when primary key is updated (one of the constants importedKeyCascade, importedKeyRestrict, importedKeySetNull), action to foreign key when primary key is deleted (one of the constants importedKeyCascade, importedKeyRestrict, importedKeySetNull), foreign key identifier, and primary key indentifier |
public abstract String getExtraNameCharacters() throws SQLException | Returns characters that can be used in unquoted identifier names besides the standard A through Z, 0 through 9, and _ |
public abstract String getIdentifierQuoteString() throws SQLException | Returns the String used to quote SQL identifiers |
public abstract ResultSet getImportedKeys(String String schema, String table) throws SQLException | Returns a ResultSet object that describes the primary key attributes that are referenced by the specified tables foreign key attributes; the ResultSet object contains the following columns: primary keys table catalog, primary keys table schema, primary keys table, primary keys column name, foreign keys table catalog, foreign keys table schema, foreign keys table, foreign keys column name, sequence number within foreign key, action to foreign key when primary key is updated (one of the constants importedKeyCascade, importedKeyRestrict, importedKeySetNull), action to foreign key when primary key is deleted (one of the constants importedKeyCascade, importedKeyRestrict, importedKeySetNull), foreign key identifier, and primary key indentifier |
public abstract ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException | Returns a ResultSet object that describes the specified tables indices and statistics; the ResultSet object contains the following columns: catalog name, schema name, table name, false boolean (if tableIndexStatic is the type), index catalog (or null if type is tableIndexStatic), index type, sequence number, column name, column sort sequence, number of unique values in the table or number of rows (if tableIndexStatic), number of pages used for the index (or the number of pages used for the table if tableIndexStatic), and filter condition (if it exists) |
public abstract int getMaxBinaryLiteralLength() throws SQLException | Returns the number of hex characters allowed in an inline binary literal |
public abstract int getMaxCatalogNameLength() throws SQLException | The maximum length for a catalog name |
public abstract int getMaxCharLiteralLength() throws SQLException | Returns the maximum length for a character literal |
public abstract int getMaxColumnNameLength() throws SQLException | Indicates the maximum length for a column name |
public abstract int getMaxColumnsInGroupBy() throws SQLException | Indicates the maximum number of columns in a GROUP BY clause |
public abstract int getMaxColumnsInIndex() throws SQLException | Indicates the maximum number of columns in an index |
public abstract int getMaxColumnsInOrderBy() throws SQLException | Indicates the maximum number of columns allowed in a ORDER BY clause |
public abstract int getMaxColumnsInSelect() throws SQLException | Indicates the maximum number of columns in a SELECT statement |
public abstract int getMaxColumnsInTable() throws SQLException | Indicates the maximum number of columns allowed in a table |
public abstract int getMaxConnections() throws SQLException | Indicates the maximum number of simultaneous connections allowed to the database |
public abstract int getMaxCursorNameLength() throws SQLException | Returns the maximum allowed length of a cursor name |
public abstract int getMaxIndexLength() throws SQLException | Returns the maximum length of an index in bytes |
public abstract int getMaxProcedureNameLength() throws SQLException | Returns the maximum allowed length of a procedure name |
public abstract int getMaxRowSize() throws SQLException | Indicates the maximum row size |
public abstract int getMaxSchemaNameLength() throws SQLException | Returns the maximum allowed length of a schema name |
public abstract int getMaxStatementLength() throws SQLException | Returns the maximum allowed length of a SQL statement |
public abstract int getMaxStatements() throws SQLException | Returns the maximum number of statements allowed at one time |
public abstract int getMaxTableNameLength() throws SQLException | Returns the maximum allowed length of a table name |
public abstract int getMaxTablesInSelect() throws SQLException | Indicates the maximum number of tables allowed in a SELECT statement |
public abstract int getMaxUserNameLength() throws SQLException | Returns the maximum allowed length of a user name |
public abstract String getNumericFunctions() throws SQLException | Returns a comma-separated list of the math functions available |
public abstract ResultSet getPrimaryKeys(String catalog, String schema, String table) throws SQLException | Returns a ResultSet object that contains the primary keys description for the specified table; the ResultSet object contains the following columns: catalog name, schema name, table name, column name, sequence number, primary key name, and, possibly, NULL |
public abstract ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException | Returns a ResultSet object that describes the catalogs stored procedures and result columns matching the specified procedureNamePatten and columnNamePattern; the ResultSet object contains the following columns: catalog name, schema name, procedure name, column or parameter name, column type, data type, data name, precision, length in bytes, scale, radix, nullability, and comments |
public abstract ResultSet getProcedures(String catalogString String procedureNamePattern) throws SQLException | Returns a ResultSet object that describes the catalogs procedures; the ResultSet object contains the following columns: catalog name, schema name, procedure name, empty column, empty column, empty column, comments about the procedure, and kind of procedure |
public abstract String getProcedureTerm() throws SQLException | Return the database-specific term for procedure |
public abstract ResultSet getSchemas() throws SQLException | Returns a ResultSet object that describes the schemas in a database; the ResultSet object contains one column that contains the schema names |
public abstract String getSchemaTerm() throws SQLException | Returns the database-specific term for schema |
public abstract String getSearchStringEscape() throws SQLException | Returns the escape characters for pattern searching |
public abstract String getSQLKeywords() throws SQLException | Returns a comma-separated list of keywords that the database recognizes, but the keywords are not SQL-92 keywords |
public abstract String getStringFunctions() throws SQLException | Returns a comma-separated list of string functions in the database |
public abstract String getSystemFunctions() throws SQLException | Returns a comma-separated list of system functions in the database |
public abstract ResultSet getTablePrivileges(String catalog, String schemaPattern schemaPattern, String tableNamePattern) throws SQLException | Returns a ResultSet object that describes the privileges for the matching and tableNamePattern; the ResultSet object contains the following columns: catalog name, schema name, table name, grantor, grantee, type of access, and YES if a grantee can grant other access |
public abstract ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String types[]) throws SQLException | Returns a ResultSet object that describes tables matching the schemaPattern and tableNamePattern; the ResultSet object contains the following columns: catalog name, schema name, table name, table type, and comments |
public abstract ResultSet getTableTypes() throws SQLException | Returns a ResultSet object that describes the table types available in the database; the ResultSet object contains the column that is a list of the table types |
public abstract String getTimeDateFunctions() throws SQLException | Returns the date and time functions for the database |
public abstract ResultSet getTypeInfo() throws SQLException | Returns a ResultSet object that describes the SQL data types supported by the database; the ResultSet object contains the columns: type name, SQL data type constants in the Types class, maximum precision, prefix used to quote a literal, suffix used to quote a literal, parameters used to create the type, nullability, case sensitivity, searchability, signed or unsigned (boolean), is it a currency, auto incrementable or not, local version of data type, minimum scale, maximum scale, empty column, empty column, and radix |
public abstract String getURL() throws SQLException | The URL for the database |
public abstract String getUserName() throws SQLException | Returns the user name as known by the database |
public abstract ResultSet getVersionColumns(String catalog, String String table) throws SQLException | Returns a ResultSet object that describes the specified tables columns that are updated when any column is updated in the table; the ResultSet object contains the following columns: empty columns, column name, SQL datatype, type name, precision, column value length in bytes, scale, and pseudoColumn or not |
public abstract boolean isCatalogAtStart() throws SQLException | Returns true if the catalog name appears at the start of a qualified table name |
public abstract boolean isReadOnly() throws SQLException | Returns true if the database is in read only mode |
public abstract boolean nullPlusNonNullIsNull() throws SQLException | Returns true if a concatenation between a NULL and non-NULL is NULL |
public abstract boolean nullsAreSortedAtEnd() throws SQLException | |
public abstract boolean nullsAreSortedAtStart() throws SQLException | |
public abstract boolean nullsAreSortedHigh() throws SQLException | |
public abstract boolean nullsAreSortedLow() throws SQLException | |
public abstract boolean storesLowerCaseIdentifiers() throws SQLException | |
public abstract boolean storesLowerCaseQuotedIdentifiers() throws SQLException | |
public abstract boolean storesMixedCaseIdentifiers() throws SQLException | |
public abstract boolean storesMixedCaseQuotedIdentifiers() throws SQLException | |
public abstract boolean storesUpperCaseIdentifiers() throws SQLException | |
public abstract boolean storesUpperCaseQuotedIdentifiers() throws SQLException | |
public abstract boolean supportsAlterTableWithAddColumn() throws SQLException | |
public abstract boolean supportsAlterTableWithDropColumn() throws SQLException | |
public abstract boolean supportsAlterTableWithDropColumn() throws SQLException | |
public abstract boolean supportsANSI92EntryLevelSQL() throws SQLException | |
public abstract boolean supportsANSI92FullSQL() throws SQLException | |
public abstract boolean supportsANSI92IntermediateSQL() throws SQLException | |
public abstract boolean supportsANSI92FullSQL() throws SQLException | |
public abstract boolean supportsCatalogsInDataManipulation() throws SQLException | |
public abstract boolean supportsCatalogsInIndexDefinitions() throws SQLException | |
public abstract boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException | |
public abstract boolean supportsCatalogsInProcedureCalls() throws SQLException | |
public abstract boolean supportsCatalogsInTableDefinitions() throws SQLException | |
public abstract boolean supportsColumnAliasing() throws SQLException | |
public abstract boolean supportsConvert() throws SQLException | |
public abstract boolean supportsConvert(int fromType, int toType) throws SQLException | |
public abstract boolean supportsCoreSQLGrammar() throws SQLException | |
public abstract boolean supportsCorrelatedSubqueries() throws SQLException | |
public abstract boolean supportsDataDefinitionAnd DataManipulationTransactions() throws SQLException | |
public abstract boolean supportsDataManipulation TransactionsOnly() throws SQLException | |
public abstract boolean supportsDifferentTableCorrelationNames() throws SQLException | |
public abstract boolean supportsExpressionsInOrderBy() throws SQLException | |
public abstract boolean supportsExtendedSQLGrammar() throws SQLException | |
public abstract boolean supportsFullOuterJoins() throws SQLException | |
public abstract boolean supportsGroupBy() throws SQLException | |
public abstract boolean supportsGroupByBeyondSelect() throws SQLException | |
public abstract boolean supportsGroupByUnrelated() throws SQLException | |
public abstract boolean supportsIntegrityEnhancementFacility() throws SQLException | |
public abstract boolean supportsLikeEscapeClause() throws SQLException | |
public abstract boolean supportsLimitedOuterJoins() throws SQLException | |
public abstract boolean supportsMinimumSQLGrammar() throws SQLException | |
public abstract boolean supportsMixedCaseIdentifiers() throws SQLException | |
public abstract boolean supportsMixedCaseQuotedIdentifiers() throws SQLException | |
public abstract boolean supportsMultipleResultSets() throws SQLException | |
public abstract boolean supportsMultipleTransactions() throws SQLException | |
public abstract boolean supportsNonNullableColumns() throws SQLException | |
public abstract boolean supportsOpenCursorsAcrossCommit() throws SQLException | |
public abstract boolean supportsOpenCursorsAcrossRollback() throws SQLException | |
public abstract boolean supportsOpenStatementsAcrossCommit() throws SQLException | |
public abstract boolean supportsOpenStatementsAcrossRollback() throws SQLException | |
public abstract boolean supportsOrderByUnrelated() throws SQLException | |
public abstract boolean supportsOuterJoins() throws SQLException | |
public abstract boolean supportsPositionedDelete() throws SQLException | |
public abstract boolean supportsPositionedUpdate() throws SQLException | |
public abstract boolean supportsSchemasInDataManipulation() throws SQLException | |
public abstract boolean supportsSchemasInProcedureCalls() throws SQLException | |
public abstract boolean supportsSchemasInProcedureCalls() throws SQLException | |
public abstract boolean supportsSchemasInTableDefinitions() throws SQLException | |
public abstract boolean supportsSelectForUpdate() throws SQLException | |
public abstract boolean supportsStoredProcedures() throws SQLException | |
public abstract boolean supportsSubqueriesInComparisons() throws SQLException | |
public abstract boolean supportsSubqueriesInExists() throws SQLException | |
public abstract boolean supportsSubqueriesInIns() throws SQLException | |
public abstract boolean supportsSubqueriesInQuantifieds() throws SQLException | |
public abstract boolean supportsTableCorrelationNames() throws SQLException | |
public abstract boolean supportsTransactionIsolationLevel(int level) throws SQLException | |
public abstract boolean supportsTransactions() throws SQLException | |
public abstract boolean supportsUnion() throws SQLException | |
public abstract boolean supportsUnionAll() throws SQLException | |
public abstract boolean usesLocalFilePerTable() throws SQLException | |
public abstract boolean usesLocalFiles() throws SQLException |
Previous | Table of Contents | Next |